Dataset statistics
| Number of variables | 20 |
|---|---|
| Number of observations | 1134 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 177.3 KiB |
| Average record size in memory | 160.1 B |
Variable types
| Numeric | 10 |
|---|---|
| Categorical | 6 |
| Unsupported | 4 |
pickup_place has a high cardinality: 189 distinct values | High cardinality |
item_name has a high cardinality: 774 distinct values | High cardinality |
item_category_name has a high cardinality: 321 distinct values | High cardinality |
how_long_it_took_to_order has a high cardinality: 862 distinct values | High cardinality |
pickup_lat is highly correlated with pickup_lon and 1 other fields | High correlation |
pickup_lon is highly correlated with pickup_lat and 1 other fields | High correlation |
dropoff_lat is highly correlated with pickup_lat and 1 other fields | High correlation |
dropoff_lon is highly correlated with pickup_lon and 1 other fields | High correlation |
pickup_lat is highly correlated with pickup_lon and 1 other fields | High correlation |
pickup_lon is highly correlated with pickup_lat and 1 other fields | High correlation |
dropoff_lat is highly correlated with pickup_lat and 1 other fields | High correlation |
dropoff_lon is highly correlated with pickup_lon and 1 other fields | High correlation |
pickup_lat is highly correlated with dropoff_lat | High correlation |
dropoff_lat is highly correlated with pickup_lat | High correlation |
place_category is highly correlated with pickup_lat and 3 other fields | High correlation |
pickup_lat is highly correlated with place_category and 3 other fields | High correlation |
pickup_lon is highly correlated with place_category and 2 other fields | High correlation |
dropoff_lat is highly correlated with place_category and 3 other fields | High correlation |
dropoff_lon is highly correlated with place_category and 3 other fields | High correlation |
distance_crossed is highly correlated with dropoff_lat | High correlation |
how_long_it_took_to_order is uniformly distributed | Uniform |
df_index has unique values | Unique |
when_the_delivery_started is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
when_the_courier_arrived_at_pickup is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
when_the_courier_left_pickup is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
when_the_courier_arrived_at_dropoff is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Reproduction
| Analysis started | 2022-01-30 01:27:33.929704 |
|---|---|
| Analysis finished | 2022-01-30 01:27:52.933505 |
| Duration | 19 seconds |
| Software version | pandas-profiling v3.1.0 |
| Download configuration | config.json |
| Distinct | 1134 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3007.124339 |
| Minimum | 4 |
|---|---|
| Maximum | 5982 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 9.0 KiB |
Quantile statistics
| Minimum | 4 |
|---|---|
| 5-th percentile | 271.95 |
| Q1 | 1516.5 |
| median | 2979 |
| Q3 | 4555.25 |
| 95-th percentile | 5733.75 |
| Maximum | 5982 |
| Range | 5978 |
| Interquartile range (IQR) | 3038.75 |
Descriptive statistics
| Standard deviation | 1737.737003 |
|---|---|
| Coefficient of variation (CV) | 0.5778733457 |
| Kurtosis | -1.199333741 |
| Mean | 3007.124339 |
| Median Absolute Deviation (MAD) | 1521.5 |
| Skewness | -0.006510232407 |
| Sum | 3410079 |
| Variance | 3019729.89 |
| Monotonicity | Strictly increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 4 | 1 | 0.1% |
| 4003 | 1 | 0.1% |
| 4028 | 1 | 0.1% |
| 4024 | 1 | 0.1% |
| 4021 | 1 | 0.1% |
| 4019 | 1 | 0.1% |
| 4017 | 1 | 0.1% |
| 4007 | 1 | 0.1% |
| 3993 | 1 | 0.1% |
| 4036 | 1 | 0.1% |
| Other values (1124) | 1124 |
| Value | Count | Frequency (%) |
| 4 | 1 | |
| 26 | 1 | |
| 27 | 1 | |
| 29 | 1 | |
| 32 | 1 | |
| 35 | 1 | |
| 46 | 1 | |
| 50 | 1 | |
| 57 | 1 | |
| 67 | 1 |
| Value | Count | Frequency (%) |
| 5982 | 1 | |
| 5975 | 1 | |
| 5973 | 1 | |
| 5958 | 1 | |
| 5957 | 1 | |
| 5955 | 1 | |
| 5952 | 1 | |
| 5950 | 1 | |
| 5949 | 1 | |
| 5948 | 1 |
delivery_id
Real number (ℝ≥0)
| Distinct | 918 |
|---|---|
| Distinct (%) | 81.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1383667.07 |
| Minimum | 1272737 |
|---|---|
| Maximum | 1491424 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 9.0 KiB |
Quantile statistics
| Minimum | 1272737 |
|---|---|
| 5-th percentile | 1286826 |
| Q1 | 1325357.25 |
| median | 1381432 |
| Q3 | 1440464.5 |
| 95-th percentile | 1480958 |
| Maximum | 1491424 |
| Range | 218687 |
| Interquartile range (IQR) | 115107.25 |
Descriptive statistics
| Standard deviation | 63921.23703 |
|---|---|
| Coefficient of variation (CV) | 0.0461969779 |
| Kurtosis | -1.260885038 |
| Mean | 1383667.07 |
| Median Absolute Deviation (MAD) | 58111 |
| Skewness | 0.03135403636 |
| Sum | 1569078457 |
| Variance | 4085924544 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1374803 | 4 | 0.4% |
| 1458212 | 4 | 0.4% |
| 1286826 | 4 | 0.4% |
| 1435427 | 4 | 0.4% |
| 1451679 | 4 | 0.4% |
| 1302788 | 4 | 0.4% |
| 1368206 | 4 | 0.4% |
| 1439953 | 4 | 0.4% |
| 1289729 | 3 | 0.3% |
| 1319803 | 3 | 0.3% |
| Other values (908) | 1096 |
| Value | Count | Frequency (%) |
| 1272737 | 1 | |
| 1272867 | 1 | |
| 1272896 | 1 | |
| 1273258 | 1 | |
| 1273986 | 1 | |
| 1274112 | 1 | |
| 1274483 | 2 | |
| 1274637 | 1 | |
| 1274791 | 1 | |
| 1274827 | 1 |
| Value | Count | Frequency (%) |
| 1491424 | 1 | 0.1% |
| 1490744 | 3 | |
| 1490119 | 2 | |
| 1489715 | 2 | |
| 1489444 | 2 | |
| 1489327 | 2 | |
| 1488977 | 2 | |
| 1488929 | 1 | 0.1% |
| 1488897 | 1 | 0.1% |
| 1488852 | 2 |
customer_id
Real number (ℝ≥0)
| Distinct | 767 |
|---|---|
| Distinct (%) | 67.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 175122.3748 |
| Minimum | 242 |
|---|---|
| Maximum | 404649 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 9.0 KiB |
Quantile statistics
| Minimum | 242 |
|---|---|
| 5-th percentile | 44368.95 |
| Q1 | 80795 |
| median | 133202 |
| Q3 | 276192 |
| 95-th percentile | 377650.4 |
| Maximum | 404649 |
| Range | 404407 |
| Interquartile range (IQR) | 195397 |
Descriptive statistics
| Standard deviation | 114493.5564 |
|---|---|
| Coefficient of variation (CV) | 0.6537917074 |
| Kurtosis | -1.034138897 |
| Mean | 175122.3748 |
| Median Absolute Deviation (MAD) | 68808 |
| Skewness | 0.6310068611 |
| Sum | 198588773 |
| Variance | 1.310877446 × 1010 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 52832 | 8 | 0.7% |
| 276192 | 7 | 0.6% |
| 270525 | 7 | 0.6% |
| 97079 | 6 | 0.5% |
| 47280 | 5 | 0.4% |
| 241719 | 5 | 0.4% |
| 151789 | 5 | 0.4% |
| 347263 | 4 | 0.4% |
| 82041 | 4 | 0.4% |
| 186473 | 4 | 0.4% |
| Other values (757) | 1079 |
| Value | Count | Frequency (%) |
| 242 | 1 | |
| 5139 | 1 | |
| 5444 | 1 | |
| 5693 | 1 | |
| 7922 | 1 | |
| 9666 | 1 | |
| 14869 | 1 | |
| 17495 | 1 | |
| 18902 | 1 | |
| 22405 | 1 |
| Value | Count | Frequency (%) |
| 404649 | 1 | |
| 403019 | 1 | |
| 402215 | 1 | |
| 402060 | 1 | |
| 400950 | 1 | |
| 400766 | 2 | |
| 399729 | 1 | |
| 399584 | 1 | |
| 399127 | 1 | |
| 398930 | 1 |
courier_id
Real number (ℝ≥0)
| Distinct | 321 |
|---|---|
| Distinct (%) | 28.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 96332.69136 |
| Minimum | 3296 |
|---|---|
| Maximum | 177847 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 9.0 KiB |
Quantile statistics
| Minimum | 3296 |
|---|---|
| 5-th percentile | 18349.7 |
| Q1 | 48473.25 |
| median | 104533 |
| Q3 | 140684 |
| 95-th percentile | 164384 |
| Maximum | 177847 |
| Range | 174551 |
| Interquartile range (IQR) | 92210.75 |
Descriptive statistics
| Standard deviation | 49682.37544 |
|---|---|
| Coefficient of variation (CV) | 0.5157374381 |
| Kurtosis | -1.250080908 |
| Mean | 96332.69136 |
| Median Absolute Deviation (MAD) | 43011.5 |
| Skewness | -0.2213600537 |
| Sum | 109241272 |
| Variance | 2468338430 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 99219 | 32 | 2.8% |
| 104533 | 19 | 1.7% |
| 61900 | 18 | 1.6% |
| 32580 | 18 | 1.6% |
| 156557 | 18 | 1.6% |
| 3296 | 16 | 1.4% |
| 22502 | 15 | 1.3% |
| 39733 | 15 | 1.3% |
| 123581 | 14 | 1.2% |
| 30743 | 14 | 1.2% |
| Other values (311) | 955 |
| Value | Count | Frequency (%) |
| 3296 | 16 | |
| 3592 | 1 | 0.1% |
| 5935 | 1 | 0.1% |
| 6715 | 1 | 0.1% |
| 6873 | 10 | |
| 7833 | 11 | |
| 8625 | 1 | 0.1% |
| 9078 | 1 | 0.1% |
| 9476 | 1 | 0.1% |
| 9549 | 4 | 0.4% |
| Value | Count | Frequency (%) |
| 177847 | 2 | |
| 175912 | 1 | 0.1% |
| 175555 | 2 | |
| 175485 | 3 | |
| 174186 | 3 | |
| 173409 | 3 | |
| 172700 | 1 | 0.1% |
| 172686 | 1 | 0.1% |
| 172399 | 2 | |
| 172301 | 2 |
vehicle_type
Categorical
| Distinct | 7 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 9.0 KiB |
| bicycle | |
|---|---|
| car | |
| walker | 36 |
| truck | 10 |
| van | 10 |
| Other values (2) | 12 |
Length
| Max length | 10 |
|---|---|
| Median length | 7 |
| Mean length | 6.157848325 |
| Min length | 3 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | bicycle |
|---|---|
| 2nd row | bicycle |
| 3rd row | bicycle |
| 4th row | bicycle |
| 5th row | bicycle |
Common Values
| Value | Count | Frequency (%) |
| bicycle | 849 | |
| car | 217 | 19.1% |
| walker | 36 | 3.2% |
| truck | 10 | 0.9% |
| van | 10 | 0.9% |
| scooter | 9 | 0.8% |
| motorcycle | 3 | 0.3% |
Length
Histogram of lengths of the category
Pie chart
| Value | Count | Frequency (%) |
| bicycle | 849 | |
| car | 217 | 19.1% |
| walker | 36 | 3.2% |
| truck | 10 | 0.9% |
| van | 10 | 0.9% |
| scooter | 9 | 0.8% |
| motorcycle | 3 | 0.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 189 |
|---|---|
| Distinct (%) | 16.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 9.0 KiB |
| The Meatball Shop | |
|---|---|
| Blue Ribbon Sushi | 66 |
| sweetgreen | 55 |
| RedFarm Broadway | 44 |
| Rubirosa | 28 |
| Other values (184) |
Length
| Max length | 33 |
|---|---|
| Median length | 14 |
| Mean length | 14.59259259 |
| Min length | 3 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 63 ? |
|---|---|
| Unique (%) | 5.6% |
Sample
| 1st row | Blue Ribbon Sushi |
|---|---|
| 2nd row | Friedman's Lunch |
| 3rd row | The Grey Dog - University |
| 4th row | Blue Ribbon Sushi Bar & Grill |
| 5th row | ilili Restaurant |
Common Values
| Value | Count | Frequency (%) |
| The Meatball Shop | 96 | 8.5% |
| Blue Ribbon Sushi | 66 | 5.8% |
| sweetgreen | 55 | 4.9% |
| RedFarm Broadway | 44 | 3.9% |
| Rubirosa | 28 | 2.5% |
| TAO | 28 | 2.5% |
| RedFarm Hudson | 26 | 2.3% |
| Parm | 25 | 2.2% |
| Han Dynasty | 25 | 2.2% |
| Sushi of Gari 46 | 23 | 2.0% |
| Other values (179) | 718 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| sushi | 164 | 5.9% |
| the | 137 | 4.9% |
| blue | 109 | 3.9% |
| ribbon | 107 | 3.9% |
| shop | 99 | 3.6% |
| meatball | 96 | 3.5% |
| redfarm | 70 | 2.5% |
| 68 | 2.5% | |
| sweetgreen | 55 | 2.0% |
| bar | 47 | 1.7% |
| Other values (299) | 1819 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 36 |
|---|---|
| Distinct (%) | 3.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 9.0 KiB |
| Italian | |
|---|---|
| Japanese | |
| Chinese | |
| Sushi | |
| American | |
| Other values (31) |
Length
| Max length | 16 |
|---|---|
| Median length | 7 |
| Mean length | 7.220458554 |
| Min length | 3 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | 0.3% |
Sample
| 1st row | Japanese |
|---|---|
| 2nd row | Breakfast |
| 3rd row | Coffee |
| 4th row | Japanese |
| 5th row | Middle Eastern |
Common Values
| Value | Count | Frequency (%) |
| Italian | 188 | |
| Japanese | 181 | |
| Chinese | 116 | |
| Sushi | 91 | 8.0% |
| American | 89 | 7.8% |
| Salad | 56 | 4.9% |
| Burger | 46 | 4.1% |
| Seafood | 35 | 3.1% |
| Indian | 33 | 2.9% |
| Mexican | 33 | 2.9% |
| Other values (26) | 266 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| italian | 188 | |
| japanese | 181 | |
| chinese | 116 | 9.7% |
| american | 104 | 8.7% |
| sushi | 91 | 7.6% |
| salad | 56 | 4.7% |
| burger | 46 | 3.9% |
| seafood | 35 | 2.9% |
| eastern | 33 | 2.8% |
| mexican | 33 | 2.8% |
| Other values (29) | 309 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 774 |
|---|---|
| Distinct (%) | 68.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 9.0 KiB |
| Chicken | 18 |
|---|---|
| Edamame | 10 |
| Spicy Tuna & Tempura Flakes | 9 |
| Cheeseburger | 9 |
| Classic Beef | 9 |
| Other values (769) |
Length
| Max length | 79 |
|---|---|
| Median length | 15 |
| Mean length | 16.77160494 |
| Min length | 3 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 609 ? |
|---|---|
| Unique (%) | 53.7% |
Sample
| 1st row | Spicy Tuna & Tempura Flakes |
|---|---|
| 2nd row | Sweet Potato Fries |
| 3rd row | Three Eggs Any Style |
| 4th row | Unagi |
| 5th row | Hommus |
Common Values
| Value | Count | Frequency (%) |
| Chicken | 18 | 1.6% |
| Edamame | 10 | 0.9% |
| Spicy Tuna & Tempura Flakes | 9 | 0.8% |
| Cheeseburger | 9 | 0.8% |
| Classic Beef | 9 | 0.8% |
| Sake | 8 | 0.7% |
| Miso | 8 | 0.7% |
| Barest Burger | 8 | 0.7% |
| Kale Caesar | 8 | 0.7% |
| House Salad | 8 | 0.7% |
| Other values (764) | 1039 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| chicken | 102 | 3.4% |
| 79 | 2.6% | |
| salad | 66 | 2.2% |
| spicy | 66 | 2.2% |
| roll | 56 | 1.8% |
| tuna | 37 | 1.2% |
| rice | 35 | 1.2% |
| with | 32 | 1.1% |
| pork | 32 | 1.1% |
| dumplings | 32 | 1.1% |
| Other values (898) | 2494 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
item_quantity
Real number (ℝ≥0)
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.16313933 |
| Minimum | 1 |
|---|---|
| Maximum | 6 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 9.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 6 |
| Range | 5 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.5321269284 |
|---|---|
| Coefficient of variation (CV) | 0.4574919915 |
| Kurtosis | 23.2637379 |
| Mean | 1.16313933 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.325086616 |
| Sum | 1319 |
| Variance | 0.2831590679 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=6)
| Value | Count | Frequency (%) |
| 1 | 1005 | |
| 2 | 93 | 8.2% |
| 3 | 21 | 1.9% |
| 4 | 12 | 1.1% |
| 6 | 2 | 0.2% |
| 5 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 1 | 1005 | |
| 2 | 93 | 8.2% |
| 3 | 21 | 1.9% |
| 4 | 12 | 1.1% |
| 5 | 1 | 0.1% |
| 6 | 2 | 0.2% |
| Value | Count | Frequency (%) |
| 6 | 2 | 0.2% |
| 5 | 1 | 0.1% |
| 4 | 12 | 1.1% |
| 3 | 21 | 1.9% |
| 2 | 93 | 8.2% |
| 1 | 1005 |
| Distinct | 321 |
|---|---|
| Distinct (%) | 28.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 9.0 KiB |
| Appetizers | 58 |
|---|---|
| Salads | 36 |
| Signatures | 35 |
| Naked Balls | 33 |
| Dim Sum | 31 |
| Other values (316) |
Length
| Max length | 53 |
|---|---|
| Median length | 10 |
| Mean length | 11.67283951 |
| Min length | 3 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 178 ? |
|---|---|
| Unique (%) | 15.7% |
Sample
| 1st row | Maki (Special Rolls) |
|---|---|
| 2nd row | Market Sides |
| 3rd row | Breakfast |
| 4th row | Taiseyo (Atlantic Ocean) |
| 5th row | Dips |
Common Values
| Value | Count | Frequency (%) |
| Appetizers | 58 | 5.1% |
| Salads | 36 | 3.2% |
| Signatures | 35 | 3.1% |
| Naked Balls | 33 | 2.9% |
| Dim Sum | 31 | 2.7% |
| Sandwiches | 28 | 2.5% |
| Maki (Special Rolls) | 24 | 2.1% |
| Sides | 22 | 1.9% |
| Entrees | 21 | 1.9% |
| Rolls | 20 | 1.8% |
| Other values (311) | 826 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 91 | 4.4% | |
| appetizers | 82 | 3.9% |
| rolls | 79 | 3.8% |
| salads | 72 | 3.4% |
| sushi | 54 | 2.6% |
| dinner | 52 | 2.5% |
| sides | 41 | 2.0% |
| special | 37 | 1.8% |
| sandwiches | 36 | 1.7% |
| signatures | 35 | 1.7% |
| Other values (322) | 1510 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 862 |
|---|---|
| Distinct (%) | 76.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 9.0 KiB |
| 06:36.3 | 5 |
|---|---|
| 07:34.7 | 4 |
| 10:48.8 | 4 |
| 21:41.4 | 4 |
| 06:02.0 | 4 |
| Other values (857) |
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 7 |
| Min length | 7 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 655 ? |
|---|---|
| Unique (%) | 57.8% |
Sample
| 1st row | 03:45.0 |
|---|---|
| 2nd row | 09:19.6 |
| 3rd row | 07:40.6 |
| 4th row | 10:21.7 |
| 5th row | 05:17.0 |
Common Values
| Value | Count | Frequency (%) |
| 06:36.3 | 5 | 0.4% |
| 07:34.7 | 4 | 0.4% |
| 10:48.8 | 4 | 0.4% |
| 21:41.4 | 4 | 0.4% |
| 06:02.0 | 4 | 0.4% |
| 02:42.0 | 4 | 0.4% |
| 08:04.4 | 4 | 0.4% |
| 06:19.9 | 4 | 0.4% |
| 08:04.8 | 4 | 0.4% |
| 03:03.8 | 4 | 0.4% |
| Other values (852) | 1093 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 06:36.3 | 5 | 0.4% |
| 08:04.8 | 4 | 0.4% |
| 15:18.0 | 4 | 0.4% |
| 05:17.8 | 4 | 0.4% |
| 14:36.9 | 4 | 0.4% |
| 04:34.3 | 4 | 0.4% |
| 11:37.0 | 4 | 0.4% |
| 03:03.8 | 4 | 0.4% |
| 07:34.7 | 4 | 0.4% |
| 06:19.9 | 4 | 0.4% |
| Other values (852) | 1093 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 213 |
|---|---|
| Distinct (%) | 18.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 40.74112718 |
| Minimum | 40.67176012 |
|---|---|
| Maximum | 40.8180821 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 9.0 KiB |
Quantile statistics
| Minimum | 40.67176012 |
|---|---|
| 5-th percentile | 40.71811007 |
| Q1 | 40.72362962 |
| median | 40.735725 |
| Q3 | 40.75893876 |
| 95-th percentile | 40.7821167 |
| Maximum | 40.8180821 |
| Range | 0.14632198 |
| Interquartile range (IQR) | 0.035309145 |
Descriptive statistics
| Standard deviation | 0.02226077121 |
|---|---|
| Coefficient of variation (CV) | 0.0005463955652 |
| Kurtosis | 0.4822409652 |
| Mean | 40.74112718 |
| Median Absolute Deviation (MAD) | 0.01297043 |
| Skewness | 0.4955914944 |
| Sum | 46200.43822 |
| Variance | 0.0004955419349 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 40.72610966 | 66 | 5.8% |
| 40.7821167 | 44 | 3.9% |
| 40.72154512 | 36 | 3.2% |
| 40.74507859 | 33 | 2.9% |
| 40.72274859 | 28 | 2.5% |
| 40.76285776 | 28 | 2.5% |
| 40.73421385 | 26 | 2.3% |
| 40.72301983 | 25 | 2.2% |
| 40.732213 | 25 | 2.2% |
| 40.78407726 | 23 | 2.0% |
| Other values (203) | 800 |
| Value | Count | Frequency (%) |
| 40.67176012 | 2 | |
| 40.67347806 | 2 | |
| 40.67425095 | 3 | |
| 40.67768312 | 2 | |
| 40.67928937 | 1 | 0.1% |
| 40.67969421 | 1 | 0.1% |
| 40.6867331 | 1 | 0.1% |
| 40.68749724 | 1 | 0.1% |
| 40.687689 | 4 | |
| 40.68853911 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 40.8180821 | 6 | 0.5% |
| 40.80254961 | 4 | 0.4% |
| 40.79606666 | 1 | 0.1% |
| 40.79039976 | 1 | 0.1% |
| 40.78761311 | 3 | 0.3% |
| 40.78516004 | 6 | 0.5% |
| 40.78487734 | 4 | 0.4% |
| 40.78407726 | 23 | |
| 40.78398734 | 1 | 0.1% |
| 40.7821167 | 44 |
| Distinct | 212 |
|---|---|
| Distinct (%) | 18.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -73.98871594 |
| Minimum | -74.01544645 |
|---|---|
| Maximum | -73.95023268 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 1134 |
| Negative (%) | 100.0% |
| Memory size | 9.0 KiB |
Quantile statistics
| Minimum | -74.01544645 |
|---|---|
| 5-th percentile | -74.0085433 |
| Q1 | -74.000286 |
| median | -73.98882151 |
| Q3 | -73.9807391 |
| 95-th percentile | -73.95754527 |
| Maximum | -73.95023268 |
| Range | 0.06521377 |
| Interquartile range (IQR) | 0.0195469 |
Descriptive statistics
| Standard deviation | 0.01390595026 |
|---|---|
| Coefficient of variation (CV) | -0.0001879469062 |
| Kurtosis | 0.1086269355 |
| Mean | -73.98871594 |
| Median Absolute Deviation (MAD) | 0.00933504 |
| Skewness | 0.6974039548 |
| Sum | -83903.20388 |
| Variance | 0.0001933754526 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -74.00249186 | 66 | 5.8% |
| -73.9807391 | 44 | 3.9% |
| -73.98884243 | 36 | 3.2% |
| -73.98882151 | 33 | 2.9% |
| -73.971619 | 28 | 2.5% |
| -73.99606192 | 28 | 2.5% |
| -74.00620203 | 26 | 2.3% |
| -73.988072 | 25 | 2.2% |
| -73.995854 | 25 | 2.2% |
| -73.97762241 | 23 | 2.0% |
| Other values (202) | 800 |
| Value | Count | Frequency (%) |
| -74.01544645 | 1 | 0.1% |
| -74.01055746 | 3 | 0.3% |
| -74.01010414 | 1 | 0.1% |
| -74.00973201 | 22 | |
| -74.00874988 | 12 | |
| -74.0086925 | 17 | |
| -74.0085433 | 3 | 0.3% |
| -74.00825065 | 17 | |
| -74.00812268 | 2 | 0.2% |
| -74.00751114 | 10 |
| Value | Count | Frequency (%) |
| -73.95023268 | 4 | 0.4% |
| -73.95165604 | 7 | 0.6% |
| -73.95278683 | 6 | 0.5% |
| -73.9544744 | 4 | 0.4% |
| -73.95518219 | 5 | 0.4% |
| -73.95524025 | 1 | 0.1% |
| -73.95592661 | 4 | 0.4% |
| -73.95633415 | 18 | |
| -73.95754527 | 9 | |
| -73.95922147 | 2 | 0.2% |
| Distinct | 737 |
|---|---|
| Distinct (%) | 65.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 40.74346596 |
| Minimum | 40.65214519 |
|---|---|
| Maximum | 40.848324 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 9.0 KiB |
Quantile statistics
| Minimum | 40.65214519 |
|---|---|
| 5-th percentile | 40.71021966 |
| Q1 | 40.72534655 |
| median | 40.7405728 |
| Q3 | 40.76166155 |
| 95-th percentile | 40.78353229 |
| Maximum | 40.848324 |
| Range | 0.19617881 |
| Interquartile range (IQR) | 0.036315 |
Descriptive statistics
| Standard deviation | 0.02412616962 |
|---|---|
| Coefficient of variation (CV) | 0.00059214819 |
| Kurtosis | 0.4244660661 |
| Mean | 40.74346596 |
| Median Absolute Deviation (MAD) | 0.0159939 |
| Skewness | 0.2891951503 |
| Sum | 46203.09039 |
| Variance | 0.0005820720606 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 40.7324282 | 8 | 0.7% |
| 40.723729 | 8 | 0.7% |
| 40.727405 | 7 | 0.6% |
| 40.739192 | 7 | 0.6% |
| 40.7233295 | 6 | 0.5% |
| 40.778028 | 6 | 0.5% |
| 40.76460273 | 6 | 0.5% |
| 40.7520764 | 6 | 0.5% |
| 40.7260641 | 6 | 0.5% |
| 40.7506213 | 5 | 0.4% |
| Other values (727) | 1069 |
| Value | Count | Frequency (%) |
| 40.65214519 | 2 | |
| 40.66688836 | 1 | |
| 40.670584 | 1 | |
| 40.674762 | 1 | |
| 40.6769679 | 1 | |
| 40.678161 | 1 | |
| 40.684222 | 1 | |
| 40.684756 | 2 | |
| 40.6853089 | 1 | |
| 40.686281 | 1 |
| Value | Count | Frequency (%) |
| 40.848324 | 1 | 0.1% |
| 40.8090213 | 1 | 0.1% |
| 40.8089292 | 2 | |
| 40.808164 | 3 | |
| 40.8073556 | 1 | 0.1% |
| 40.80646979 | 1 | 0.1% |
| 40.806465 | 1 | 0.1% |
| 40.80566 | 2 | |
| 40.8049122 | 2 | |
| 40.8046535 | 1 | 0.1% |
| Distinct | 737 |
|---|---|
| Distinct (%) | 65.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -73.98668972 |
| Minimum | -74.0176786 |
|---|---|
| Maximum | -73.93488 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 1134 |
| Negative (%) | 100.0% |
| Memory size | 9.0 KiB |
Quantile statistics
| Minimum | -74.0176786 |
|---|---|
| 5-th percentile | -74.00961075 |
| Q1 | -74.001549 |
| median | -73.9902554 |
| Q3 | -73.975954 |
| 95-th percentile | -73.95387245 |
| Maximum | -73.93488 |
| Range | 0.0827986 |
| Interquartile range (IQR) | 0.025595 |
Descriptive statistics
| Standard deviation | 0.01784718385 |
|---|---|
| Coefficient of variation (CV) | -0.0002412215483 |
| Kurtosis | -0.4802902637 |
| Mean | -73.98668972 |
| Median Absolute Deviation (MAD) | 0.011989035 |
| Skewness | 0.6145893871 |
| Sum | -83900.90614 |
| Variance | 0.0003185219714 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -74.0040761 | 8 | 0.7% |
| -74.0080594 | 8 | 0.7% |
| -73.991802 | 7 | 0.6% |
| -73.987326 | 7 | 0.6% |
| -74.0010156 | 6 | 0.5% |
| -73.953851 | 6 | 0.5% |
| -73.98010481 | 6 | 0.5% |
| -73.9915018 | 6 | 0.5% |
| -73.9897793 | 6 | 0.5% |
| -73.9902554 | 5 | 0.4% |
| Other values (727) | 1069 |
| Value | Count | Frequency (%) |
| -74.0176786 | 2 | |
| -74.016943 | 2 | |
| -74.0168879 | 1 | 0.1% |
| -74.0158665 | 3 | |
| -74.015617 | 1 | 0.1% |
| -74.0155753 | 1 | 0.1% |
| -74.0151411 | 1 | 0.1% |
| -74.0148234 | 1 | 0.1% |
| -74.0142304 | 1 | 0.1% |
| -74.014192 | 2 |
| Value | Count | Frequency (%) |
| -73.93488 | 4 | |
| -73.940635 | 1 | 0.1% |
| -73.9410377 | 3 | |
| -73.941521 | 1 | 0.1% |
| -73.9421558 | 1 | 0.1% |
| -73.942873 | 2 | |
| -73.943522 | 1 | 0.1% |
| -73.9443896 | 2 | |
| -73.945621 | 2 | |
| -73.94567694 | 2 |
| Distinct | 867 |
|---|---|
| Distinct (%) | 76.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.709489926 |
| Minimum | 0.02828587842 |
|---|---|
| Maximum | 12.02197417 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 9.0 KiB |
Quantile statistics
| Minimum | 0.02828587842 |
|---|---|
| 5-th percentile | 0.3581607419 |
| Q1 | 0.8335324382 |
| median | 1.361151338 |
| Q3 | 2.16849021 |
| 95-th percentile | 4.291154938 |
| Maximum | 12.02197417 |
| Range | 11.99368829 |
| Interquartile range (IQR) | 1.334957772 |
Descriptive statistics
| Standard deviation | 1.326627512 |
|---|---|
| Coefficient of variation (CV) | 0.7760370457 |
| Kurtosis | 7.422955246 |
| Mean | 1.709489926 |
| Median Absolute Deviation (MAD) | 0.6166009038 |
| Skewness | 2.205710774 |
| Sum | 1938.561576 |
| Variance | 1.759940554 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.6515454668 | 5 | 0.4% |
| 1.36931776 | 4 | 0.4% |
| 0.3054693314 | 4 | 0.4% |
| 1.700970587 | 4 | 0.4% |
| 4.700592215 | 4 | 0.4% |
| 1.407350773 | 4 | 0.4% |
| 1.891782664 | 4 | 0.4% |
| 2.16849021 | 4 | 0.4% |
| 1.716854023 | 4 | 0.4% |
| 1.315486031 | 4 | 0.4% |
| Other values (857) | 1093 |
| Value | Count | Frequency (%) |
| 0.02828587842 | 3 | |
| 0.1221776603 | 1 | 0.1% |
| 0.1542575859 | 1 | 0.1% |
| 0.1695097633 | 1 | 0.1% |
| 0.1772446698 | 2 | |
| 0.1774262775 | 1 | 0.1% |
| 0.1870827022 | 1 | 0.1% |
| 0.2076893937 | 1 | 0.1% |
| 0.2201976565 | 2 | |
| 0.2334528053 | 2 |
| Value | Count | Frequency (%) |
| 12.02197417 | 1 | 0.1% |
| 8.867912912 | 1 | 0.1% |
| 8.290087092 | 1 | 0.1% |
| 7.471350941 | 1 | 0.1% |
| 7.44928056 | 4 | |
| 7.215911332 | 1 | 0.1% |
| 7.172200179 | 1 | 0.1% |
| 7.158111227 | 1 | 0.1% |
| 6.999986686 | 2 | |
| 6.725983826 | 1 | 0.1% |
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here. A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
First rows
| df_index | delivery_id | customer_id | courier_id | vehicle_type | pickup_place | place_category | item_name | item_quantity | item_category_name | how_long_it_took_to_order | pickup_lat | pickup_lon | dropoff_lat | dropoff_lon | when_the_delivery_started | when_the_courier_arrived_at_pickup | when_the_courier_left_pickup | when_the_courier_arrived_at_dropoff | distance_crossed | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 4 | 1327707 | 122609 | 118095 | bicycle | Blue Ribbon Sushi | Japanese | Spicy Tuna & Tempura Flakes | 2.0 | Maki (Special Rolls) | 03:45.0 | 40.726110 | -74.002492 | 40.709323 | -74.015867 | 00:07:18.500000 | 00:14:42.700000 | 00:25:19.400000 | 00:48:27.200000 | 2.179898 |
| 1 | 26 | 1459871 | 391543 | 7833 | bicycle | Friedman's Lunch | Breakfast | Sweet Potato Fries | 1.0 | Market Sides | 09:19.6 | 40.742681 | -74.006236 | 40.740126 | -74.004687 | 00:14:29.800000 | 00:30:04.300000 | 00:41:53.900000 | 00:47:32 | 0.312452 |
| 2 | 27 | 1419674 | 81591 | 96818 | bicycle | The Grey Dog - University | Coffee | Three Eggs Any Style | 1.0 | Breakfast | 07:40.6 | 40.733787 | -73.993035 | 40.744274 | -73.980459 | 00:05:55 | 00:18:07.100000 | 00:34:28.200000 | 00:50:48.900000 | 1.576253 |
| 3 | 29 | 1282272 | 97991 | 72941 | bicycle | Blue Ribbon Sushi Bar & Grill | Japanese | Unagi | 1.0 | Taiseyo (Atlantic Ocean) | 10:21.7 | 40.767653 | -73.982925 | 40.748828 | -73.990139 | 00:02:41 | 00:11:48.200000 | 00:28:00.700000 | 00:45:08.700000 | 2.177474 |
| 4 | 32 | 1467996 | 301380 | 142394 | bicycle | ilili Restaurant | Middle Eastern | Hommus | 1.0 | Dips | 05:17.0 | 40.744188 | -73.987531 | 40.734994 | -73.987709 | 00:18:37.400000 | 00:30:46.400000 | 00:46:07.100000 | 00:57:18.100000 | 1.021089 |
| 5 | 35 | 1314550 | 348787 | 119813 | bicycle | Otto Enoteca Pizzeria | Italian | Lentils ���Toscana� | 1.0 | Vegetables | 22:42.9 | 40.732064 | -73.996155 | 40.767582 | -73.983704 | 00:40:38.800000 | 00:49:50 | 00:27:58.500000 | 00:55:56.800000 | 4.081993 |
| 6 | 46 | 1379189 | 47440 | 112646 | bicycle | Bareburger | Burger | Barest Burger | 1.0 | Bareburgers | 06:25.1 | 40.728478 | -73.998392 | 40.715170 | -74.011601 | 00:54:08.300000 | 00:57:53.900000 | 00:08:40.400000 | 00:23:14.700000 | 1.851868 |
| 7 | 50 | 1322133 | 49104 | 156557 | car | Empanada Mama (closed) | Mexican | Reggaeton | 1.0 | Wheat Flour | 05:35.0 | 40.764217 | -73.988321 | 40.747897 | -74.003608 | 00:10:10.300000 | 00:21:06.700000 | 00:33:26.100000 | 00:42:17.500000 | 2.225111 |
| 8 | 57 | 1401304 | 68116 | 67103 | truck | Blue Ribbon Sushi Izakaya | Japanese | Rock Shrimp & Crispy Garlic Teriyaki | 1.0 | Kushi Yaki (Skewers) | 08:13.9 | 40.721980 | -73.988148 | 40.729999 | -73.993688 | 00:30:30.500000 | 00:47:48.300000 | 00:01:10.300000 | 00:22:12.800000 | 1.006065 |
| 9 | 67 | 1325129 | 41991 | 108647 | bicycle | Blue Ribbon Sushi Bar & Grill | Japanese | Tamago | 1.0 | Taiheiyo (Pacific Ocean) | 12:20.8 | 40.767653 | -73.982925 | 40.763269 | -73.963113 | 00:01:43.800000 | 00:23:34.100000 | 00:38:53.500000 | 00:49:00.300000 | 1.742220 |
Last rows
| df_index | delivery_id | customer_id | courier_id | vehicle_type | pickup_place | place_category | item_name | item_quantity | item_category_name | how_long_it_took_to_order | pickup_lat | pickup_lon | dropoff_lat | dropoff_lon | when_the_delivery_started | when_the_courier_arrived_at_pickup | when_the_courier_left_pickup | when_the_courier_arrived_at_dropoff | distance_crossed | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1124 | 5948 | 1441230 | 111581 | 52502 | bicycle | Caracas Arepa Bar | South American | De Pabellon | 1.0 | Arepas | 03:59.0 | 40.726810 | -73.985329 | 40.734876 | -73.986658 | 00:07:11.500000 | 00:14:31.400000 | 00:35:21.500000 | 00:43:09.200000 | 0.902734 |
| 1125 | 5949 | 1369210 | 117810 | 156557 | car | Momoya | Sushi | Crispy Rice | 1.0 | Signature Roll | 05:14.2 | 40.784077 | -73.977622 | 40.784312 | -73.951934 | 00:05:37.800000 | 00:14:53.700000 | 00:26:14.500000 | 00:37:21.100000 | 2.168490 |
| 1126 | 5950 | 1386459 | 331143 | 104533 | bicycle | Waverly Diner | American | Chicken Fingers | 2.0 | Appetizers & Finger Foods | 06:38.1 | 40.733012 | -74.000056 | 40.732486 | -73.996585 | 00:14:29.800000 | 00:36:13.100000 | 00:52:07.800000 | 00:55:43.300000 | 0.298980 |
| 1127 | 5952 | 1347879 | 40500 | 130599 | bicycle | J. G. Melon | Burger | Bacon Cheeseburger | 1.0 | Main Menu | 05:32.2 | 40.771135 | -73.959623 | 40.766204 | -73.960757 | 00:08:42.800000 | 00:19:13.600000 | 00:34:33.700000 | 00:42:57.300000 | 0.555946 |
| 1128 | 5955 | 1350096 | 99288 | 120179 | car | Sushi of Gari 46 | Sushi | Edamame | 1.0 | Appetizers | 24:25.1 | 40.760654 | -73.989583 | 40.716209 | -74.015575 | 00:19:48.900000 | 00:59:28.200000 | 00:37:32.500000 | 00:57:22.900000 | 5.401863 |
| 1129 | 5957 | 1362524 | 95164 | 32580 | bicycle | Amma | Indian | Naan | 3.0 | Breads | 05:50.9 | 40.755702 | -73.968587 | 40.779801 | -73.987650 | 00:10:23.100000 | 00:27:14.500000 | 00:19:05.200000 | 00:36:27.400000 | 3.122970 |
| 1130 | 5958 | 1294906 | 221206 | 113300 | bicycle | Empanada Mama (closed) | Mexican | Pizza | 1.0 | Wheat Flour | 07:35.7 | 40.764217 | -73.988321 | 40.779967 | -73.983335 | 00:29:10.100000 | 00:30:32.500000 | 00:05:52.600000 | 00:18:40.400000 | 1.798971 |
| 1131 | 5973 | 1379953 | 127103 | 69993 | bicycle | The Grey Dog - University | Coffee | Organic Raw Veggies | 1.0 | Small Plates | 04:34.4 | 40.733787 | -73.993035 | 40.736760 | -73.982048 | 00:35:30 | 00:43:14.400000 | 00:50:04.600000 | 00:57:28.400000 | 0.985082 |
| 1132 | 5975 | 1475459 | 303211 | 156557 | car | Big Nick's Burgers & Pizza | Pizza | Chicken Fingers | 1.0 | Appetizers & Side Orders | 05:11.1 | 40.776767 | -73.979120 | 40.793834 | -73.941521 | 00:47:25.900000 | 00:48:56.200000 | 00:11:46.100000 | 00:25:02.100000 | 3.696529 |
| 1133 | 5982 | 1357449 | 128517 | 134189 | car | RedFarm Broadway | Chinese | Pan-Fried Pork Buns (4) | 1.0 | Dim Sum | 09:25.3 | 40.782117 | -73.980739 | 40.732714 | -73.995040 | 00:30:44.500000 | 00:40:22.500000 | 00:06:02.100000 | 00:31:54.400000 | 5.617469 |